select distinct demo.last_name "Last name", demo.first_name "First name" , demo.hin "PHN", demo.phone "Phone number", CONCAT( demo.address, ", ", demo.city, ", ", demo.province, ", ", demo.postal) as "Address", CONCAT( "", "eChart", "" ) AS "eChart", CONCAT( "", "mFile", "" ) AS "Master File" from demographic demo where demo.provider_no = '{provider_no}' and demo.email ='' select '%' as provider_no, 'All Providers' as provider union select provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider where status='1' and provider_type='doctor' and ohip_no>1 and ohip_no != 123456 order by provider_no;